-- 目的中心到不同网点分段货量统计汇总
CREATE EXTERNAL TABLE jms_dm.dm_end_center_network_time_interval_summary_dt(
  `scantime` date COMMENT '卸车到件日期',
  `end_center_code` string COMMENT '末端中心编码',
  `end_center_name` string COMMENT '末端中心名称',
  `subordinate_agent_code` string COMMENT '代理区编码',
  `subordinate_agent_name` string COMMENT '代理区名称',
  `end_network_code` string COMMENT '末端网点编码',
  `end_network_name` string COMMENT '末端网点名称',
  `bill_cnt` int COMMENT '汇总量',
  `time_stage00` int COMMENT '时段0',
  `time_stage01` int COMMENT '时段1',
  `time_stage02` int COMMENT '时段2',
  `time_stage03` int COMMENT '时段3',
  `time_stage04` int COMMENT '时段4',
  `time_stage05` int COMMENT '时段5',
  `time_stage06` int COMMENT '时段6',
  `time_stage07` int COMMENT '时段7',
  `time_stage08` int COMMENT '时段8',
  `time_stage09` int COMMENT '时段9',
  `time_stage10` int COMMENT '时段10',
  `time_stage11` int COMMENT '时段11',
  `time_stage12` int COMMENT '时段12',
  `time_stage13` int COMMENT '时段13',
  `time_stage14` int COMMENT '时段14',
  `time_stage15` int COMMENT '时段15',
  `time_stage16` int COMMENT '时段16',
  `time_stage17` int COMMENT '时段17',
  `time_stage18` int COMMENT '时段18',
  `time_stage19` int COMMENT '时段19',
  `time_stage20` int COMMENT '时段20',
  `time_stage21` int COMMENT '时段21',
  `time_stage22` int COMMENT '时段22',
  `time_stage23` int COMMENT '时段23')
COMMENT '目的中心到目的网点时段统计'
PARTITIONED BY (
  `dt` string COMMENT '日期分区(卸车到件时间)')
   STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_end_center_network_time_interval_summary_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );